SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 243871 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 243871 [ RunTime:0.002215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543329,302977,463303,128865,981829,302767,168895,1014674,152400,433853,387887,683511,946337,142961,403066,229368,986880,578365,518357,622757,803544,193405,509537,863188,146063,607138,718078,408758,742496,629319,848657,50717,200968,184763,362572,712649,521004,128879,738205,116921,674646,562522,920463,889913,728070,181223,181441,68235,1017266,355562,759215,969651,632467,252542,1001840,141419,523469,856799,911949,290598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 243871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 243871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]