SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 252103 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 252103 [ RunTime:0.001840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029877,48601,534453,356182,708341,325217,375774,982001,138570,132985,325168,399227,771839,579585,249466,936939,113454,691111,976364,739697,723982,571718,378781,737111,216044,459484,1003241,1024532,33806,77904,573011,498168,665178,605212,689730,929868,110738,118333,568739,714224,880819,882644,633638,72751,465327,287523,757940,868019,386171,247354,381622,966624,927142,923426,506434,702500,967201,817751,489698,439563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 252103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000923s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 252103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]