SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533501 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533501 [ RunTime:0.001486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (962719,472680,522746,255841,870919,735348,347443,227580,720144,656666,75004,505001,533857,62439,474199,462226,903185,985257,142532,502505,617995,507323,558319,59678,267648,353080,918437,404332,498163,1035026,701578,347322,228301,542709,986119,450396,377040,691996,457904,1034682,11970,711950,18666,471348,365932,1008915,993364,626585,68569,841354,926509,644376,432914,574264,146145,875320,1014755,598434,434554,780026) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]