SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524711 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524711 [ RunTime:0.001928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393614,1045295,8173,821175,468020,676924,635704,500176,378552,170719,420053,117288,470567,262484,971789,117580,226519,327446,939053,464410,692398,615630,985620,946512,772565,467806,447144,1007439,541714,730999,877585,2806,933280,726111,854871,709908,63724,264719,223602,497381,808918,608460,741420,659453,1039024,470294,593441,762938,87301,565859,283058,558068,825265,219714,288630,896934,843112,372258,86530,673890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]