SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003013s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48140 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48140 [ RunTime:0.002725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (397820,595630,608263,916707,417116,763875,478389,518765,831412,938391,162169,457669,280315,492312,360393,699054,905238,775502,542755,947104,899364,693795,440829,947745,440690,210173,334286,964245,992856,339473,798940,328482,744034,430,798937,723277,522247,886491,445114,108866,210217,251215,545361,600914,231709,495903,583031,721325,49774,90189,174869,1034977,620947,673353,620271,18123,651517,708645,617075,17520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]