SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 118984 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 118984 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721545,427395,990864,170790,187228,417237,927099,251539,107015,515557,141787,1000905,186926,226178,228303,672833,1002769,834978,854656,681851,1001548,336513,1007295,65950,955760,926209,697069,1036596,254570,1041517,219572,280056,586887,378577,785334,969767,304108,788463,124514,973499,645955,365837,26041,803474,427698,847325,785381,387671,624277,164923,390060,927735,212006,11473,727260,734213,676180,189048,187805,909560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 118984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 118984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000382s ]