SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43238 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43238 [ RunTime:0.002083s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (711729,624839,74538,663628,18811,273451,556282,1001468,807032,714882,765047,682472,16453,959095,234733,209843,4242,978741,804203,762089,228588,492055,325002,654107,229044,657031,156504,818001,862052,323413,231580,114111,63257,804917,700097,827900,816749,389080,971175,1046922,382533,822670,211487,443926,361189,400310,993552,730366,184042,926045,1020737,454000,554832,512966,525828,42043,739739,576648,957457,27354) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]