SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014533 LIMIT 1 [ RunTime:0.004041s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014533 [ RunTime:0.003580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455098,212800,562479,820025,532594,216721,683214,125644,244043,186519,805602,256798,322509,19934,204265,189277,314011,881224,485620,620843,47610,649986,813212,185110,8748,968895,369338,938516,822588,307167,395866,498053,50173,960140,682028,499819,139114,365970,245825,552961,504924,410612,828370,721569,379047,569613,899414,227345,91964,714921,149013,333213,713034,901173,903246,772170,599326,902323,898648,746239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002847s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014533 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000701s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014533 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002102s ]