SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51399 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51399 [ RunTime:0.001853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150545,982060,980108,258071,947922,325033,225197,884433,178525,741316,675710,572718,417361,874898,1012064,1039752,216586,699712,610689,93843,1025001,896533,396170,96675,391376,142854,367409,745520,632078,185437,185776,787215,459608,191198,825487,526692,1927,322152,274085,282264,73603,244954,453790,25614,501903,846200,161494,296783,661640,1022142,458258,726476,559458,542116,150782,667986,303866,191868,301723,857858) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]