SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001441s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401908 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401908 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (759025,49619,808801,232100,252485,945706,645946,884556,665480,223513,609348,571057,278254,848458,539313,151484,503668,619479,307282,545467,178893,746540,343046,103262,573602,608225,260045,34581,616502,139173,376665,223142,1036525,488625,1002879,118470,491457,1021353,614563,943546,244660,1009845,169729,82679,2522,501586,843959,429384,1008077,532608,282069,849683,237547,719717,451809,118028,959123,23201,403478,287665) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]