SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286023 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286023 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497566,278555,242690,753340,898145,23105,718105,126600,262318,5738,585466,486446,904044,590356,301368,585198,1038507,1012101,664495,499721,804702,211704,519814,708201,327723,259696,642428,305372,169436,796334,865376,575643,67120,232622,565524,85291,1035515,554892,369194,1048280,565872,177536,606855,53449,279239,331359,674977,237609,871808,299501,771730,221341,810314,786393,393411,718206,117890,160710,636862,568253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000379s ]