SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809720 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809720 [ RunTime:0.002337s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (685475,582556,845985,114106,1032993,279445,733232,118350,470690,882186,1004352,865398,332778,886979,193511,844089,391228,117403,226385,711573,509727,748881,1005617,161941,286734,621128,126344,718378,133680,302327,954100,948601,489804,391241,170975,1042015,892344,63379,67674,134222,1033787,504319,924991,189236,333480,480940,312346,662190,691565,178305,803062,415890,911453,382888,459076,25920,1024179,356341,753261,30552) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002815s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809720 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809720 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]