SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502713 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502713 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6498,367610,431875,831570,47043,757247,1024258,570100,560955,612191,331903,696840,35492,439122,204707,558857,801984,959112,520400,638476,663508,863189,934927,756566,914757,703328,820439,686210,483321,72087,230617,4040,852918,538584,927394,675366,489841,487997,139908,84357,982664,108298,794386,557855,296704,874514,179383,266953,655764,788174,154512,256943,1038152,969774,287511,25376,33758,201217,908260,568443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]